I tried to follow How to open an Excel file in C# tutorial, i.e. added a reference on the Com tab to Microsoft Office 14.0 Object Library and tried to compile code:
using Excel = Microsoft.Office.Interop.Excel;
//...
Excel.Application xlApp;
Excel.Workbook xlWorkBook;
Excel.Worksheet xlWorkSheet;
xlApp = new Excel.ApplicationClass();//error here
//...
and faced a compile-time error, saying
There is no constructor defined for Microsoft.Office.Interop.Excel.ApplicationClass type.
What am I missing?
Anonymous User
14-Nov-2013Use the following to open it:
xlApp = CreateObject("Excel.Application");CreateObject creates and returns a reference to a COM object